Looking for a little farming help from the math whizzes in the crowd
So, I've decided to take up farming as a hobby between gvg matches and while waiting for chapter 2 to come out. I have a series of builds I'm happy with in various popular locations throughout the game, but to make it more interesting I thought I might track these things to determine A) which are the most efficient places to farm and B) does drop quality in fact diminish over repeated runs?
So I've started an excel spreadsheet that tracks the following per run:
Time spent
XP Gained
Gold earned (post selling)
Gold Drops
Purple Drops
Blue Drops
White Drops
Estimated drop resale value to players
But the trouble is I'm not totally sure what to DO with this information. I'm no math whiz, although I am enough of a geek to come up with an excel spreadsheet for this stuff. Can anyone come up with a formula that will ultimately deliver a number rating the effectiveness of a given run, so that they can be compared? I'm not sure XP should be a factor, and I worry that the whole player resale value is rather vague, but I'm sure the amount of time taken should factor in - for example, UW solo runs have the chance of being very profitable, as do SF runs, but they take considerably longer than a simple griffon run.
|